清空quartz数据库

626次阅读
没有评论

共计 883 个字符,预计需要花费 3 分钟才能阅读完成。

表顺序如下:

delete from qrtz_CRON_TRIGGERS where 1=1;
delete from qrtz_SIMPLE_TRIGGERS where 1=1;
delete from qrtz_TRIGGERS where 1=1;
delete from qrtz_JOB_DETAILS where 1=1;
delete from qrtz_FIRED_TRIGGERS where 1=1;
delete from qrtz_LOCKS where 1=1;
delete from qrtz_SCHEDULER_STATE where 1=1;

delete from qrtz_BLOB_TRIGGERS where 1=1;
delete from qrtz_CALENDARS where 1=1;
delete from qrtz_PAUSED_TRIGGER_GRPS where 1=1;
delete from qrtz_SIMPROP_TRIGGERS where 1=1;

或者:

SET FOREIGN_KEY_CHECKS=0;
DELETE FROM `qrtz_locks` where 1=1;
DELETE FROM `qrtz_paused_trigger_grps` where 1=1;
DELETE FROM `qrtz_scheduler_state` where 1=1;
DELETE FROM `qrtz_calendars` where 1=1;
DELETE FROM `qrtz_job_details` where 1=1;
DELETE FROM `qrtz_triggers` where 1=1;
DELETE FROM `qrtz_blob_triggers` where 1=1;
DELETE FROM `qrtz_cron_triggers` where 1=1;
DELETE FROM `qrtz_simple_triggers` where 1=1;
DELETE FROM `qrtz_simprop_triggers` where 1=1;
DELETE FROM `qrtz_fired_triggers` where 1=1;
SET FOREIGN_KEY_CHECKS=0;
正文完
 
评论(没有评论)